﻿CREATE TABLE [dbo].[SIPaperUserAnswerItem]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
	[UserAnswerId] INT NOT NULL, 
    [QuestionId] INT NOT NULL, 
    [AnswerItemId] INT NOT NULL,
	[RecCreateDt] DATETIME NOT NULL, 
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自动编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'问题编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'QuestionId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'答案项编号 -1为未选定答案',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'AnswerItemId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录创建时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'RecCreateDt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'用户答卷编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'SIPaperUserAnswerItem',
    @level2type = N'COLUMN',
    @level2name = N'UserAnswerId'